Loading the SQL File 6
Connect to SQL Server
Server Name: hypv8669.hostedbyappliedi.net
User Name: ColaberryPowerBIReporting
Password: Colaberry99
Database Name: ColaberryPowerBI_Reporting
This is the screenshot that shows how to connect to Colaberry Server
Loading data from SQL to power bi to create visuals
Open power bi desktop
Click on get data on the left side of the upper ribbon
Choose SQL then put server name and database name
Import the data to power bi desktop
Then view your data
The next step: open power bi desktop
Load your data to power bi desktop
Server name: hypv8669.hostedbyappliedi.net
database name: ColaberryPowerBI_Reporting
To have date table query click on this button
go to model
Create relationships between the date table and main data tio
How to create date table and main data relationship
To install power bi desktop use this link
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables